1.A specified RECEIVE statement modifies or returns at least one row to a Service Broker queue.
指定的RECEIVE语句至少修改一行或并将其返回到ServiceBroker队列。
2.For a given conversation, a RECEIVE statement returns messages with a status of 1 in ascending message_sequence_number order.
对于给定的会话,RECEIVE语句将返回status为1的消息,并将消息按message_sequence_number的升序排列。
3.If the queue specified in the RECEIVE statement has the queue status set to OFF, the statement fails with a Transact-SQL error.
如果RECEIVE语句指定的队列的队列状态设置为OFF,则该语句将失败,并返回Transact-SQL错误。
4.The RECEIVE statement locks the conversation group for the messages returned until the transaction that contains the statement completes.
RECEIVE语句将锁定返回的消息所属的会话组,直到包含该语句的事务完成为止。
5.Number of sessions that are currently waiting within a RECEIVE statement for this queue.
当前正在RECEIVE语句中等待此队列的会话数。
6.Specifies that the RECEIVE statement waits for a message to arrive on the queue, if no messages are currently present.
指定如果当前没有消息,则RECEIVE语句将等待消息到达队列。
7.This number includes any session executing a receive statement, regardless of whether the queue monitor started the session.
此数字包括任何执行接收语句的会话,不管队列监视器是否启动了该会话。
8.The WHERE clause of the RECEIVE statement may only contain search conditions that use conversation_handle or conversation_group_id.
RECEIVE语句的WHERE子句可能只包含使用conversation_handle或conversation_group_id的搜索条件。
9.TIMEOUT can be specified in the RECEIVE statement or in the GET CONVERSATION GROUP statement.
可以在RECEIVE语句或GETCONVERSATIONGROUP语句中指定TIMEOUT。
10.The RECEIVE statement removes received messages from the queue unless the queue specifies message retention.
RECEIVE语句将从队列中删除已收到的消息,但队列指定消息保持时除外。